package com.jiuyun.dao;

import com.jiuyun.entity.Classes;
import com.jiuyun.entity.HomeWork;
import com.jiuyun.entity.Student;

import java.sql.SQLException;
import java.util.List;

public interface ClassesDao {

    //获取所有班级信息
    public List<Classes> getClasses() throws SQLException;
    //通过班级名称查询出班级id
    public Classes findclass(String className) throws  SQLException;


    public List getstudent(String name) throws  SQLException;

    //获取某班所有学生
    public List getstud(int classid) throws  SQLException;

    //获取某月、某班的作业情况
    public List homework(int classid,int year,int month) throws SQLException;

    //添加学生student数据
    int getpupil(int stid,int classid,String stname,String stpass) throws SQLException;

    // 增加作业情况
    public int addhomework(HomeWork work) throws SQLException;

    public  Student findstudent(int stuid) throws  SQLException;

    public int addhomework(int stuid,String data,String bz) throws SQLException;

}
